<%@ page language="java" contentType="text/html; charset=UTF8"
	pageEncoding="UTF8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
<meta name="categories" content="MySQL">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
<title>MySQL将表数据单独存放文件</title>
</head>
<body>
	<div class="article-wrapper">
		<article>
			<h1 class="title">MySQL将表数据单独存放文件</h1>
			<hr>
			<section>
				<p>MySQL将表数据分开表示的方法：</p>
				<code> show variables like ‘%innodb%’; </code>
				<p>查看innodb_file_per_table变量是否为ON，如果为OFF，则将该变量设置成ON。设置完毕后，再建表，就回生成单独的文件。文件的目录是MySQL的data目录。</p>
			</section>
		</article>
	</div>
</body>
</html>
